A User-Friendly Approach to Design a Multidimensional Model from Relational Databases
نویسندگان
چکیده
Data in a data warehouse is organized in a multidimensional model. This multidimensional model helps in faster query processing and efficient OLAP operations for data analysis and decision making. In this paper, we introduce a framework which proposes design methodologies to map the relational database into a multidimensional model. The process starts with first cleaning the relational database and then categorizing the attributes of this cleansed relational database into metrics and dimensional attributes by applying the proposed set of mapping rules. This approach has been analyzed using the case study of bank management system and has been implemented successfully using WAMP 2.0 (PHP 5.3.0 and
منابع مشابه
FIESTA: a framework for schema evolution in multidimensional databases
New application areas for databases like data warehousing and OLAP (Online Analytical Processing) deploy the multidimensional data model in order to describe the application domain. Consequently, OLAP systems are represented by a multidimensional database schema to adequately reflect the application semantics. FIESTA presents a methodology for the evolution of such multidimensional schemas. Cor...
متن کاملA Logical Approach to Multidimensional Databases
In this paper we present MD, a logical model for OLAP systems, and show how it can be used in the design of multidimensional databases. Unlike other models for multidimensional databases, MD is independent of any speci c implementation (relational or proprietary multidimensional) and as such it provides a clear separation between practical and conceptual aspects. In this framework, we present a...
متن کاملA New User Framework to Design MD Model from Relational One
127 Abstract Data in a data warehouse is organized in a multidimensional model. This multidimensional model helps in faster query processing and efficient OLAP operations for data analysis and decision making. In this paper, we introduce a framework which proposes design methodologies to map the relational database into a multidimensional model. The process starts with first cleaning the relati...
متن کاملMultidimensional Database Representation of Real-time, Volatile, and Multi-behavioral Environments
Traditional relational and multidimensional databases are poorly equipped to deal with data collected from dynamic and volatile environments, where characteristics and conditions are erratic or goals of the system could alter rapidly. These databases’ data models of real-world objects require human involvement for creation and modification, since neither relational nor multidimensional database...
متن کاملUser-Centric Spatial DataWarehousing: A Survey of Requirements & Approaches
Data warehouses have traditionally been used to analyse large multidimensional datasets and provide enterprise decision support. With an increased availability of spatial data in recent years, several new strategies have been proposed to enable their integration into data warehouses and OLAP systems and perform complex analysis on them. One strategy to achieve this is to integrate existing Geog...
متن کامل